package com.xkcoding.orm.mybatis.mapper;

import com.xkcoding.orm.mybatis.entity.Dz;
import com.xkcoding.orm.mybatis.entity.Gd;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * <p>
 * User Mapper
 * </p>
 *
 * @author yangkai.shen
 * @date Created in 2018-11-08 10:54
 */
@Mapper
@Component
public interface GdMapper {

    @Select("SELECT gj,ph,sj FROM gd group by gj,ph,sj")
    List<Gd> selectGjAndPh();



}
